package sopt.dev.db;

/**
 * Created by Dev on 13. 8. 1.
 */
public class CityInfoDB {

	/**
	 * @author
	 */
	public static final class CityDBScheme {

		private CityDBScheme() {
		}

		public static final String TABLE_NAME = "CITY_TABLE ";

		public static final String COLUMN_ID = "CITY_ID ";
		public static final String COLUMN_CITYNAME = "CITY_NAME ";
		public static final String COLUMN_INDATE = "IN_DATE ";
		public static final String COLUMN_OUTDATE = "OUT_DATE ";
		public static final String COLUMN_IMG_PATH = "CITY_IMG_PATH ";
		public static final String COLUMN_CURRENCY = "CITY_CURRENCY ";

		public static String[] getColumnNames() {
			return new String[]{ COLUMN_ID, COLUMN_CITYNAME, COLUMN_INDATE, 
					COLUMN_OUTDATE, COLUMN_IMG_PATH, COLUMN_CURRENCY };
		}
		
		public static String getColumnNamesInRow() {
			
			StringBuilder sb = new StringBuilder();
			
			for(String column : getColumnNames()) {
				sb.append(column + " , ");		
			}
			
			return sb.toString();
		}

	}
}
